Telco EDA Report

Brought to you by YData

Dataset statistics

Number of variables	19
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.2 MiB
Average record size in memory	653.2 B

Variable types

Text	1
Categorical	6
Numeric	9
Boolean	3

Alerts

`avg_data_usage_gb` is highly overall correlated with `monthly_spend` and 1 other fields	High correlation
`duration` is highly overall correlated with `product_id` and 1 other fields	High correlation
`gaming` is highly overall correlated with `product_id` and 2 other fields	High correlation
`monthly_spend` is highly overall correlated with `avg_data_usage_gb` and 1 other fields	High correlation
`product_id` is highly overall correlated with `duration` and 5 other fields	High correlation
`product_name` is highly overall correlated with `duration` and 5 other fields	High correlation
`social_media` is highly overall correlated with `product_id` and 2 other fields	High correlation
`spending_tier` is highly overall correlated with `avg_data_usage_gb` and 1 other fields	High correlation
`streaming` is highly overall correlated with `product_id` and 2 other fields	High correlation
`target_offer` is highly overall correlated with `gaming` and 4 other fields	High correlation
`customer_id` has unique values	Unique
`travel_score` has unique values	Unique
`pct_video_usage` has 236 (2.4%) zeros	Zeros
`topup_freq` has 476 (4.8%) zeros	Zeros
`complaint_count` has 6132 (61.3%) zeros	Zeros

Reproduction

Analysis started	2025-11-13 17:17:37.149284
Analysis finished	2025-11-13 17:18:00.162038
Duration	23.01 seconds
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

customer_id
Text

Unique

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	537.2 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	60000
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10000 ?
Unique (%)	100.0%

Sample

1st row	C00001
2nd row	C00002
3rd row	C00003
4th row	C00004
5th row	C00005

Value	Count	Frequency (%)
c00001	1	< 0.1%
c00009	1	< 0.1%
c00018	1	< 0.1%
c00003	1	< 0.1%
c00004	1	< 0.1%
c00005	1	< 0.1%
c00006	1	< 0.1%
c00007	1	< 0.1%
c00008	1	< 0.1%
c00010	1	< 0.1%
Other values (9990)	9990	99.9%

Most occurring characters

Value	Count	Frequency (%)
0	13999	23.3%
C	10000	16.7%
1	4001	6.7%
6	4000	6.7%
7	4000	6.7%
4	4000	6.7%
5	4000	6.7%
8	4000	6.7%
9	4000	6.7%
2	4000	6.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	60000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	13999	23.3%
C	10000	16.7%
1	4001	6.7%
6	4000	6.7%
7	4000	6.7%
4	4000	6.7%
5	4000	6.7%
8	4000	6.7%
9	4000	6.7%
2	4000	6.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	60000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	13999	23.3%
C	10000	16.7%
1	4001	6.7%
6	4000	6.7%
7	4000	6.7%
4	4000	6.7%
5	4000	6.7%
8	4000	6.7%
9	4000	6.7%
2	4000	6.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	60000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	13999	23.3%
C	10000	16.7%
1	4001	6.7%
6	4000	6.7%
7	4000	6.7%
4	4000	6.7%
5	4000	6.7%
8	4000	6.7%
9	4000	6.7%
2	4000	6.7%

plan_type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	550.8 KiB

Prepaid	6108
Postpaid	3892

Length

Max length	8
Median length	7
Mean length	7.3892
Min length	7

Characters and Unicode

Total characters	73892
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Prepaid
2nd row	Postpaid
3rd row	Postpaid
4th row	Prepaid
5th row	Prepaid

Common Values

Value	Count	Frequency (%)
Prepaid	6108	61.1%
Postpaid	3892	38.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
prepaid	6108	61.1%
postpaid	3892	38.9%

Most occurring characters

Value	Count	Frequency (%)
P	10000	13.5%
p	10000	13.5%
a	10000	13.5%
i	10000	13.5%
d	10000	13.5%
r	6108	8.3%
e	6108	8.3%
o	3892	5.3%
s	3892	5.3%
t	3892	5.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	73892	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
P	10000	13.5%
p	10000	13.5%
a	10000	13.5%
i	10000	13.5%
d	10000	13.5%
r	6108	8.3%
e	6108	8.3%
o	3892	5.3%
s	3892	5.3%
t	3892	5.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	73892	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
P	10000	13.5%
p	10000	13.5%
a	10000	13.5%
i	10000	13.5%
d	10000	13.5%
r	6108	8.3%
e	6108	8.3%
o	3892	5.3%
s	3892	5.3%
t	3892	5.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	73892	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
P	10000	13.5%
p	10000	13.5%
a	10000	13.5%
i	10000	13.5%
d	10000	13.5%
r	6108	8.3%
e	6108	8.3%
o	3892	5.3%
s	3892	5.3%
t	3892	5.3%

device_brand
Categorical

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	531.9 KiB

Realme	1509
Xiaomi	1458
Samsung	1439
Huawei	1438
Vivo	1395
Other values (2)	2761

Length

Max length	7
Median length	6
Mean length	5.4513
Min length	4

Characters and Unicode

Total characters	54513
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Realme
2nd row	Vivo
3rd row	Xiaomi
4th row	Apple
5th row	Huawei

Common Values

Value	Count	Frequency (%)
Realme	1509	15.1%
Xiaomi	1458	14.6%
Samsung	1439	14.4%
Huawei	1438	14.4%
Vivo	1395	14.0%
Apple	1386	13.9%
Oppo	1375	13.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
realme	1509	15.1%
xiaomi	1458	14.6%
samsung	1439	14.4%
huawei	1438	14.4%
vivo	1395	14.0%
apple	1386	13.9%
oppo	1375	13.8%

Most occurring characters

Value	Count	Frequency (%)
a	5844	10.7%
e	5842	10.7%
i	5749	10.5%
p	5522	10.1%
m	4406	8.1%
o	4228	7.8%
l	2895	5.3%
u	2877	5.3%
R	1509	2.8%
X	1458	2.7%
Other values (10)	14183	26.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	54513	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	5844	10.7%
e	5842	10.7%
i	5749	10.5%
p	5522	10.1%
m	4406	8.1%
o	4228	7.8%
l	2895	5.3%
u	2877	5.3%
R	1509	2.8%
X	1458	2.7%
Other values (10)	14183	26.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	54513	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	5844	10.7%
e	5842	10.7%
i	5749	10.5%
p	5522	10.1%
m	4406	8.1%
o	4228	7.8%
l	2895	5.3%
u	2877	5.3%
R	1509	2.8%
X	1458	2.7%
Other values (10)	14183	26.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	54513	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	5844	10.7%
e	5842	10.7%
i	5749	10.5%
p	5522	10.1%
m	4406	8.1%
o	4228	7.8%
l	2895	5.3%
u	2877	5.3%
R	1509	2.8%
X	1458	2.7%
Other values (10)	14183	26.0%

avg_data_usage_gb
Real number (ℝ)

High correlation

Distinct	1712
Distinct (%)	17.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.958883

Minimum	0.03
Maximum	39.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0.03
5-th percentile	1.13
Q1	2.87
median	4.99
Q3	8.04
95-th percentile	14.19
Maximum	39.02
Range	38.99
Interquartile range (IQR)	5.17

Descriptive statistics

Standard deviation	4.1929093
Coefficient of variation (CV)	0.70364014
Kurtosis	2.7748617
Mean	5.958883
Median Absolute Deviation (MAD)	2.45
Skewness	1.3873462
Sum	59588.83
Variance	17.580488
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.39	26	0.3%
3.02	23	0.2%
2.16	21	0.2%
2.65	21	0.2%
1.78	20	0.2%
5.62	20	0.2%
4.18	20	0.2%
4.69	20	0.2%
3.27	19	0.2%
2.05	19	0.2%
Other values (1702)	9791	97.9%

Value	Count	Frequency (%)
0.03	1	< 0.1%
0.04	2	< 0.1%
0.06	1	< 0.1%
0.08	1	< 0.1%
0.12	1	< 0.1%
0.13	2	< 0.1%
0.14	3	< 0.1%
0.15	3	< 0.1%
0.16	1	< 0.1%
0.17	3	< 0.1%

Value	Count	Frequency (%)
39.02	1	< 0.1%
33.15	1	< 0.1%
30.66	1	< 0.1%
30.44	1	< 0.1%
29.97	1	< 0.1%
27.84	1	< 0.1%
26.99	1	< 0.1%
26.92	1	< 0.1%
26.82	1	< 0.1%
26.08	1	< 0.1%

pct_video_usage
Real number (ℝ)

Zeros

Distinct	9749
Distinct (%)	97.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.40263889

Minimum	0
Maximum	1
Zeros	236
Zeros (%)	2.4%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0.070404882
Q1	0.26529046
median	0.4001155
Q3	0.53516088
95-th percentile	0.72682106
Maximum	1
Range	1
Interquartile range (IQR)	0.26987042

Descriptive statistics

Standard deviation	0.19574145
Coefficient of variation (CV)	0.48614642
Kurtosis	-0.24568729
Mean	0.40263889
Median Absolute Deviation (MAD)	0.13493808
Skewness	0.11790369
Sum	4026.3889
Variance	0.038314717
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	236	2.4%
1	17	0.2%
0.804146026	1	< 0.1%
0.341826802	1	< 0.1%
0.709332363	1	< 0.1%
0.610009213	1	< 0.1%
0.629036856	1	< 0.1%
0.089818063	1	< 0.1%
0.438641899	1	< 0.1%
0.475566051	1	< 0.1%
Other values (9739)	9739	97.4%

Value	Count	Frequency (%)
0	236	2.4%
0.000168478	1	< 0.1%
0.001037455	1	< 0.1%
0.001370626	1	< 0.1%
0.001950845	1	< 0.1%
0.00291208	1	< 0.1%
0.003496372	1	< 0.1%
0.004638417	1	< 0.1%
0.004673963	1	< 0.1%
0.004691242	1	< 0.1%

Value	Count	Frequency (%)
1	17	0.2%
0.997666702	1	< 0.1%
0.989796185	1	< 0.1%
0.988209616	1	< 0.1%
0.981982115	1	< 0.1%
0.978086539	1	< 0.1%
0.97587673	1	< 0.1%
0.974465945	1	< 0.1%
0.973972507	1	< 0.1%
0.972343273	1	< 0.1%

avg_call_duration
Real number (ℝ)

Distinct	2229
Distinct (%)	22.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.971357

Minimum	-8.37
Maximum	27.77
Zeros	0
Zeros (%)	0.0%
Negative	229
Negative (%)	2.3%
Memory size	78.3 KiB

Quantile statistics

Minimum	-8.37
5-th percentile	1.74
Q1	6.65
median	10.02
Q3	13.32
95-th percentile	18.02
Maximum	27.77
Range	36.14
Interquartile range (IQR)	6.67

Descriptive statistics

Standard deviation	4.9549927
Coefficient of variation (CV)	0.4969226
Kurtosis	-0.0069078222
Mean	9.971357
Median Absolute Deviation (MAD)	3.33
Skewness	-0.036472282
Sum	99713.57
Variance	24.551952
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.73	19	0.2%
11.03	18	0.2%
12.91	15	0.1%
10.76	15	0.1%
9.25	15	0.1%
8.86	15	0.1%
11.88	14	0.1%
8.04	14	0.1%
10.26	14	0.1%
9.58	14	0.1%
Other values (2219)	9847	98.5%

Value	Count	Frequency (%)
-8.37	1	< 0.1%
-7.13	1	< 0.1%
-7.12	1	< 0.1%
-6.94	1	< 0.1%
-6.81	1	< 0.1%
-6.73	1	< 0.1%
-6.68	1	< 0.1%
-6.53	1	< 0.1%
-6.45	1	< 0.1%
-6.04	1	< 0.1%

Value	Count	Frequency (%)
27.77	1	< 0.1%
27.73	1	< 0.1%
27.3	1	< 0.1%
26.84	1	< 0.1%
26.81	1	< 0.1%
26.32	1	< 0.1%
25.99	1	< 0.1%
25.96	1	< 0.1%
25.89	1	< 0.1%
25.83	1	< 0.1%

sms_freq
Real number (ℝ)

Distinct	28
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.0108

Minimum	4
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	4
5-th percentile	9
Q1	12
median	15
Q3	18
95-th percentile	22
Maximum	31
Range	27
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.8727746
Coefficient of variation (CV)	0.25799921
Kurtosis	0.090199895
Mean	15.0108
Median Absolute Deviation (MAD)	3
Skewness	0.27597848
Sum	150108
Variance	14.998383
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
15	1029	10.3%
14	1000	10.0%
13	990	9.9%
16	943	9.4%
17	859	8.6%
12	829	8.3%
18	688	6.9%
11	685	6.9%
19	575	5.8%
10	472	4.7%
Other values (18)	1930	19.3%

Value	Count	Frequency (%)
4	10	0.1%
5	15	0.1%
6	46	0.5%
7	110	1.1%
8	191	1.9%
9	309	3.1%
10	472	4.7%
11	685	6.9%
12	829	8.3%
13	990	9.9%

Value	Count	Frequency (%)
31	4	< 0.1%
30	1	< 0.1%
29	8	0.1%
28	4	< 0.1%
27	18	0.2%
26	32	0.3%
25	50	0.5%
24	82	0.8%
23	126	1.3%
22	199	2.0%

monthly_spend
Real number (ℝ)

High correlation

Distinct	308
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	109776.5

Minimum	-13000
Maximum	450000
Zeros	0
Zeros (%)	0.0%
Negative	2
Negative (%)	< 0.1%
Memory size	78.3 KiB

Quantile statistics

Minimum	-13000
5-th percentile	49000
Q1	78000
median	102000
Q3	135000
95-th percentile	196000
Maximum	450000
Range	463000
Interquartile range (IQR)	57000

Descriptive statistics

Standard deviation	46237.322
Coefficient of variation (CV)	0.42119508
Kurtosis	2.038817
Mean	109776.5
Median Absolute Deviation (MAD)	28000
Skewness	1.0602815
Sum	1.097765 × 10⁹
Variance	2.1378899 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81000	124	1.2%
82000	121	1.2%
85000	115	1.1%
90000	113	1.1%
95000	112	1.1%
89000	110	1.1%
98000	105	1.1%
100000	104	1.0%
78000	103	1.0%
87000	103	1.0%
Other values (298)	8890	88.9%

Value	Count	Frequency (%)
-13000	1	< 0.1%
-6000	1	< 0.1%
2000	1	< 0.1%
5000	1	< 0.1%
7000	1	< 0.1%
8000	2	< 0.1%
9000	1	< 0.1%
12000	3	< 0.1%
13000	2	< 0.1%
14000	1	< 0.1%

Value	Count	Frequency (%)
450000	1	< 0.1%
372000	1	< 0.1%
363000	1	< 0.1%
354000	1	< 0.1%
350000	1	< 0.1%
349000	1	< 0.1%
337000	1	< 0.1%
333000	2	< 0.1%
330000	1	< 0.1%
324000	2	< 0.1%

topup_freq
Real number (ℝ)

Zeros

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.9866

Minimum	0
Maximum	12
Zeros	476
Zeros (%)	4.8%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	6
Maximum	12
Range	12
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.7098283
Coefficient of variation (CV)	0.57249993
Kurtosis	0.32893541
Mean	2.9866
Median Absolute Deviation (MAD)	1
Skewness	0.57530473
Sum	29866
Variance	2.9235128
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	2293	22.9%
2	2236	22.4%
4	1701	17.0%
1	1512	15.1%
5	970	9.7%
6	493	4.9%
0	476	4.8%
7	209	2.1%
8	72	0.7%
9	30	0.3%
Other values (2)	8	0.1%

Value	Count	Frequency (%)
0	476	4.8%
1	1512	15.1%
2	2236	22.4%
3	2293	22.9%
4	1701	17.0%
5	970	9.7%
6	493	4.9%
7	209	2.1%
8	72	0.7%
9	30	0.3%

Value	Count	Frequency (%)
12	1	< 0.1%
10	7	0.1%
9	30	0.3%
8	72	0.7%
7	209	2.1%
6	493	4.9%
5	970	9.7%
4	1701	17.0%
3	2293	22.9%
2	2236	22.4%

travel_score
Real number (ℝ)

Unique

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2824407

Minimum	0.003375549
Maximum	0.85481359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0.003375549
5-th percentile	0.061392273
Q1	0.15877515
median	0.2612058
Q3	0.3856562
95-th percentile	0.57436417
Maximum	0.85481359
Range	0.85143804
Interquartile range (IQR)	0.22688105

Descriptive statistics

Standard deviation	0.15836636
Coefficient of variation (CV)	0.56070658
Kurtosis	-0.090670875
Mean	0.2824407
Median Absolute Deviation (MAD)	0.11067369
Skewness	0.60349188
Sum	2824.407
Variance	0.025079903
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.284418997	1	< 0.1%
0.396435784	1	< 0.1%
0.091934321	1	< 0.1%
0.085950298	1	< 0.1%
0.408043587	1	< 0.1%
0.549135717	1	< 0.1%
0.04287208	1	< 0.1%
0.054140744	1	< 0.1%
0.339828978	1	< 0.1%
0.152164423	1	< 0.1%
Other values (9990)	9990	99.9%

Value	Count	Frequency (%)
0.003375549	1	< 0.1%
0.004111988	1	< 0.1%
0.005014107	1	< 0.1%
0.005295472	1	< 0.1%
0.005297941	1	< 0.1%
0.006518227	1	< 0.1%
0.006590649	1	< 0.1%
0.006789953	1	< 0.1%
0.006900476	1	< 0.1%
0.007161406	1	< 0.1%

Value	Count	Frequency (%)
0.854813593	1	< 0.1%
0.844166874	1	< 0.1%
0.843125354	1	< 0.1%
0.839215961	1	< 0.1%
0.833735033	1	< 0.1%
0.833201455	1	< 0.1%
0.826561214	1	< 0.1%
0.823822346	1	< 0.1%
0.823366141	1	< 0.1%
0.823009678	1	< 0.1%

complaint_count
Real number (ℝ)

Zeros

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4926

Minimum	0
Maximum	5
Zeros	6132
Zeros (%)	61.3%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.70412699
Coefficient of variation (CV)	1.4294092
Kurtosis	1.8459323
Mean	0.4926
Median Absolute Deviation (MAD)	0
Skewness	1.4076191
Sum	4926
Variance	0.49579482
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	6132	61.3%
1	2964	29.6%
2	766	7.7%
3	123	1.2%
4	14	0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
0	6132	61.3%
1	2964	29.6%
2	766	7.7%
3	123	1.2%
4	14	0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
5	1	< 0.1%
4	14	0.1%
3	123	1.2%
2	766	7.7%
1	2964	29.6%
0	6132	61.3%

product_id
Real number (ℝ)

High correlation

Distinct	25
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.886

Minimum	1
Maximum	25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	7
median	13
Q3	19
95-th percentile	24
Maximum	25
Range	24
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	7.1678269
Coefficient of variation (CV)	0.55624917
Kurtosis	-1.1893821
Mean	12.886
Median Absolute Deviation (MAD)	6
Skewness	0.024858226
Sum	128860
Variance	51.377742
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
7	434	4.3%
12	431	4.3%
3	426	4.3%
14	419	4.2%
4	418	4.2%
6	412	4.1%
18	411	4.1%
19	410	4.1%
22	407	4.1%
10	407	4.1%
Other values (15)	5825	58.2%

Value	Count	Frequency (%)
1	406	4.1%
2	368	3.7%
3	426	4.3%
4	418	4.2%
5	377	3.8%
6	412	4.1%
7	434	4.3%
8	401	4.0%
9	402	4.0%
10	407	4.1%

Value	Count	Frequency (%)
25	395	4.0%
24	369	3.7%
23	384	3.8%
22	407	4.1%
21	365	3.6%
20	403	4.0%
19	410	4.1%
18	411	4.1%
17	359	3.6%
16	386	3.9%

product_name
Categorical

High correlation

Distinct	25
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	865.2 KiB

100gb 220k (internet only 7)	434
90gb 240k (60gb internet + 10gb stream + 10gb game + 10gb socmed, pahe 4)	431
25gb 80k (internet only 3)	426
5gb 10k (internet only harian 1)	419
35gb 100k (internet only 4)	418
Other values (20)	7872

Length

Max length	75
Median length	59
Mean length	39.5877
Min length	26

Characters and Unicode

Total characters	395877
Distinct characters	34
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	10gb 50k (internet only 1)
2nd row	20gb 45k (internet + stream mingguan)
3rd row	10gb 15k (internet only harian 2)
4th row	15gb 65k (internet only 2)
5th row	3gb 8k (internet only hemat 1)

Common Values

Value	Count	Frequency (%)
100gb 220k (internet only 7)	434	4.3%
90gb 240k (60gb internet + 10gb stream + 10gb game + 10gb socmed, pahe 4)	431	4.3%
25gb 80k (internet only 3)	426	4.3%
5gb 10k (internet only harian 1)	419	4.2%
35gb 100k (internet only 4)	418	4.2%
80gb 200k (internet only 6)	412	4.1%
20gb 45k (internet + stream mingguan)	411	4.1%
12gb 30k (internet only 14 hari 1)	410	4.1%
6gb 20k (internet + game mingguan)	407	4.1%
30gb 100k (25gb internet + 5gb stream + 5gb game, pahe 2)	407	4.1%
Other values (15)	5825	58.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
internet	10000	13.1%
	8033	10.5%
only	5607	7.4%
10gb	4475	5.9%
stream	4022	5.3%
1	3177	4.2%
5gb	2406	3.2%
mingguan	2323	3.0%
game	2050	2.7%
pahe	2045	2.7%
Other values (51)	32134	42.1%

Most occurring characters

Value	Count	Frequency (%)
	66672	16.8%
n	31446	7.9%
e	30895	7.8%
t	24807	6.3%
g	24464	6.2%
0	18423	4.7%
b	17768	4.5%
r	16028	4.0%
a	14424	3.6%
i	14329	3.6%
Other values (24)	136621	34.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	395877	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	66672	16.8%
n	31446	7.9%
e	30895	7.8%
t	24807	6.3%
g	24464	6.2%
0	18423	4.7%
b	17768	4.5%
r	16028	4.0%
a	14424	3.6%
i	14329	3.6%
Other values (24)	136621	34.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	395877	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	66672	16.8%
n	31446	7.9%
e	30895	7.8%
t	24807	6.3%
g	24464	6.2%
0	18423	4.7%
b	17768	4.5%
r	16028	4.0%
a	14424	3.6%
i	14329	3.6%
Other values (24)	136621	34.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	395877	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	66672	16.8%
n	31446	7.9%
e	30895	7.8%
t	24807	6.3%
g	24464	6.2%
0	18423	4.7%
b	17768	4.5%
r	16028	4.0%
a	14424	3.6%
i	14329	3.6%
Other values (24)	136621	34.5%

spending_tier
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	509.6 KiB

mid	5597
low	2677
high	1726

Length

Max length	4
Median length	3
Mean length	3.1726
Min length	3

Characters and Unicode

Total characters	31726
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	low
2nd row	low
3rd row	mid
4th row	low
5th row	low

Common Values

Value	Count	Frequency (%)
mid	5597	56.0%
low	2677	26.8%
high	1726	17.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mid	5597	56.0%
low	2677	26.8%
high	1726	17.3%

Most occurring characters

Value	Count	Frequency (%)
i	7323	23.1%
m	5597	17.6%
d	5597	17.6%
h	3452	10.9%
l	2677	8.4%
o	2677	8.4%
w	2677	8.4%
g	1726	5.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	31726	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	7323	23.1%
m	5597	17.6%
d	5597	17.6%
h	3452	10.9%
l	2677	8.4%
o	2677	8.4%
w	2677	8.4%
g	1726	5.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	31726	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	7323	23.1%
m	5597	17.6%
d	5597	17.6%
h	3452	10.9%
l	2677	8.4%
o	2677	8.4%
w	2677	8.4%
g	1726	5.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	31726	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	7323	23.1%
m	5597	17.6%
d	5597	17.6%
h	3452	10.9%
l	2677	8.4%
o	2677	8.4%
w	2677	8.4%
g	1726	5.4%

duration
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	543.2 KiB

30 hari	5287
7 hari	2323
1 hari	1577
14 hari	813

Length

Max length	7
Median length	7
Mean length	6.61
Min length	6

Characters and Unicode

Total characters	66100
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	30 hari
2nd row	7 hari
3rd row	1 hari
4th row	30 hari
5th row	1 hari

Common Values

Value	Count	Frequency (%)
30 hari	5287	52.9%
7 hari	2323	23.2%
1 hari	1577	15.8%
14 hari	813	8.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hari	10000	50.0%
30	5287	26.4%
7	2323	11.6%
1	1577	7.9%
14	813	4.1%

Most occurring characters

Value	Count	Frequency (%)
	10000	15.1%
h	10000	15.1%
a	10000	15.1%
r	10000	15.1%
i	10000	15.1%
3	5287	8.0%
0	5287	8.0%
1	2390	3.6%
7	2323	3.5%
4	813	1.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	66100	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	10000	15.1%
h	10000	15.1%
a	10000	15.1%
r	10000	15.1%
i	10000	15.1%
3	5287	8.0%
0	5287	8.0%
1	2390	3.6%
7	2323	3.5%
4	813	1.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	66100	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	10000	15.1%
h	10000	15.1%
a	10000	15.1%
r	10000	15.1%
i	10000	15.1%
3	5287	8.0%
0	5287	8.0%
1	2390	3.6%
7	2323	3.5%
4	813	1.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	66100	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	10000	15.1%
h	10000	15.1%
a	10000	15.1%
r	10000	15.1%
i	10000	15.1%
3	5287	8.0%
0	5287	8.0%
1	2390	3.6%
7	2323	3.5%
4	813	1.2%

streaming
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 KiB

False	6379
True	3621

Value	Count	Frequency (%)
False	6379	63.8%
True	3621	36.2%

gaming
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 KiB

False	7950
True	2050

Value	Count	Frequency (%)
False	7950	79.5%
True	2050	20.5%

social_media
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 KiB

False	8007
True	1993

Value	Count	Frequency (%)
False	8007	80.1%
True	1993	19.9%

target_offer
Categorical

High correlation

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	637.4 KiB

General Offer	5607
Allrounder offer	2050
Streaming partner offer	1181
Stream and social media offer	797
Social media offer	365

Length

Max length	29
Median length	13
Mean length	16.2537
Min length	13

Characters and Unicode

Total characters	162537
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	General Offer
2nd row	Streaming partner offer
3rd row	General Offer
4th row	General Offer
5th row	General Offer

Common Values

Value	Count	Frequency (%)
General Offer	5607	56.1%
Allrounder offer	2050	20.5%
Streaming partner offer	1181	11.8%
Stream and social media offer	797	8.0%
Social media offer	365	3.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
offer	10000	41.8%
general	5607	23.4%
allrounder	2050	8.6%
streaming	1181	4.9%
partner	1181	4.9%
social	1162	4.9%
media	1162	4.9%
stream	797	3.3%
and	797	3.3%

Most occurring characters

Value	Count	Frequency (%)
e	27585	17.0%
r	24047	14.8%
f	20000	12.3%
	13937	8.6%
a	11887	7.3%
l	10869	6.7%
n	10816	6.7%
o	7605	4.7%
G	5607	3.4%
O	5607	3.4%
Other values (11)	24577	15.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	162537	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	27585	17.0%
r	24047	14.8%
f	20000	12.3%
	13937	8.6%
a	11887	7.3%
l	10869	6.7%
n	10816	6.7%
o	7605	4.7%
G	5607	3.4%
O	5607	3.4%
Other values (11)	24577	15.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	162537	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	27585	17.0%
r	24047	14.8%
f	20000	12.3%
	13937	8.6%
a	11887	7.3%
l	10869	6.7%
n	10816	6.7%
o	7605	4.7%
G	5607	3.4%
O	5607	3.4%
Other values (11)	24577	15.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	162537	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	27585	17.0%
r	24047	14.8%
f	20000	12.3%
	13937	8.6%
a	11887	7.3%
l	10869	6.7%
n	10816	6.7%
o	7605	4.7%
G	5607	3.4%
O	5607	3.4%
Other values (11)	24577	15.1%

	avg_call_duration	avg_data_usage_gb	complaint_count	device_brand	duration	gaming	monthly_spend	pct_video_usage	plan_type	product_id	product_name	sms_freq	social_media	spending_tier	streaming	target_offer	topup_freq	travel_score
avg_call_duration	1.000	-0.013	-0.010	0.000	0.019	0.000	-0.012	-0.007	0.000	0.014	0.011	0.008	0.030	0.021	0.000	0.000	-0.002	-0.016
avg_data_usage_gb	-0.013	1.000	0.008	0.000	0.014	0.021	0.854	0.024	0.000	-0.027	0.016	-0.008	0.000	0.661	0.021	0.011	0.018	0.010
complaint_count	-0.010	0.008	1.000	0.010	0.000	0.008	0.007	-0.003	0.015	-0.004	0.000	-0.002	0.000	0.000	0.000	0.000	0.001	-0.017
device_brand	0.000	0.000	0.010	1.000	0.012	0.000	0.000	0.000	0.000	0.000	0.004	0.000	0.000	0.000	0.000	0.000	0.002	0.000
duration	0.019	0.014	0.000	0.012	1.000	0.314	0.003	0.000	0.000	0.870	0.999	0.013	0.295	0.017	0.284	0.341	0.000	0.013
gaming	0.000	0.021	0.008	0.000	0.314	1.000	0.000	0.000	0.000	0.870	0.999	0.008	0.261	0.000	0.464	1.000	0.000	0.000
monthly_spend	-0.012	0.854	0.007	0.000	0.003	0.000	1.000	0.019	0.000	-0.035	0.000	-0.005	0.000	0.901	0.024	0.017	0.010	0.014
pct_video_usage	-0.007	0.024	-0.003	0.000	0.000	0.000	0.019	1.000	0.022	-0.008	0.000	0.021	0.000	0.014	0.000	0.000	-0.008	-0.001
plan_type	0.000	0.000	0.015	0.000	0.000	0.000	0.000	0.022	1.000	0.000	0.008	0.028	0.006	0.000	0.000	0.000	0.028	0.008
product_id	0.014	-0.027	-0.004	0.000	0.870	0.870	-0.035	-0.008	0.000	1.000	0.999	0.006	0.647	0.015	0.808	0.686	-0.019	0.001
product_name	0.011	0.016	0.000	0.004	0.999	0.999	0.000	0.000	0.008	0.999	1.000	0.010	0.999	0.000	0.999	0.999	0.000	0.014
sms_freq	0.008	-0.008	-0.002	0.000	0.013	0.008	-0.005	0.021	0.028	0.006	0.010	1.000	0.000	0.004	0.000	0.000	0.012	0.002
social_media	0.030	0.000	0.000	0.000	0.295	0.261	0.000	0.000	0.006	0.647	0.999	0.000	1.000	0.000	0.472	0.831	0.000	0.035
spending_tier	0.021	0.661	0.000	0.000	0.017	0.000	0.901	0.014	0.000	0.015	0.000	0.004	0.000	1.000	0.000	0.000	0.000	0.014
streaming	0.000	0.021	0.000	0.000	0.284	0.464	0.024	0.000	0.000	0.808	0.999	0.000	0.472	0.000	1.000	0.927	0.000	0.009
target_offer	0.000	0.011	0.000	0.000	0.341	1.000	0.017	0.000	0.000	0.686	0.999	0.000	0.831	0.000	0.927	1.000	0.000	0.000
topup_freq	-0.002	0.018	0.001	0.002	0.000	0.000	0.010	-0.008	0.028	-0.019	0.000	0.012	0.000	0.000	0.000	0.000	1.000	0.001
travel_score	-0.016	0.010	-0.017	0.000	0.013	0.000	0.014	-0.001	0.008	0.001	0.014	0.002	0.035	0.014	0.009	0.000	0.001	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	customer_id	plan_type	device_brand	avg_data_usage_gb	pct_video_usage	avg_call_duration	sms_freq	monthly_spend	topup_freq	travel_score	complaint_count	product_id	product_name	spending_tier	duration	streaming	gaming	social_media	target_offer
0	C00001	Prepaid	Realme	1.50	0.804146	7.98	13	70000	4	0.284419	0	1	10gb 50k (internet only 1)	low	30 hari	no	no	no	General Offer
1	C00002	Postpaid	Vivo	1.09	0.107686	9.56	9	63000	3	0.115086	0	18	20gb 45k (internet + stream mingguan)	low	7 hari	yes	no	no	Streaming partner offer
2	C00003	Postpaid	Xiaomi	3.24	0.313894	4.61	13	89000	7	0.402998	0	15	10gb 15k (internet only harian 2)	mid	1 hari	no	no	no	General Offer
3	C00004	Prepaid	Apple	5.32	0.420158	6.96	8	67000	4	0.302169	0	2	15gb 65k (internet only 2)	low	30 hari	no	no	no	General Offer
4	C00005	Prepaid	Huawei	1.91	0.251638	11.01	21	72000	5	0.487911	0	23	3gb 8k (internet only hemat 1)	low	1 hari	no	no	no	General Offer
5	C00006	Prepaid	Oppo	3.30	0.478873	6.53	17	54000	3	0.372135	0	6	80gb 200k (internet only 6)	low	30 hari	no	no	no	General Offer
6	C00007	Prepaid	Oppo	9.87	0.375882	11.17	11	140000	5	0.308220	1	7	100gb 220k (internet only 7)	mid	30 hari	no	no	no	General Offer
7	C00008	Postpaid	Oppo	13.91	0.465977	7.72	14	180000	4	0.288257	2	5	50gb 150k (internet only 5)	high	30 hari	no	no	no	General Offer
8	C00009	Postpaid	Realme	1.25	0.222178	10.73	20	72000	2	0.270601	0	9	35gb 120k (25gb internet + 5gb stream + 5gb socmed, pahe 1)	low	30 hari	yes	no	yes	Stream and social media offer
9	C00010	Postpaid	Huawei	3.66	0.196774	13.36	11	83000	1	0.342730	0	5	50gb 150k (internet only 5)	mid	30 hari	no	no	no	General Offer

	customer_id	plan_type	device_brand	avg_data_usage_gb	pct_video_usage	avg_call_duration	sms_freq	monthly_spend	topup_freq	travel_score	complaint_count	product_id	product_name	spending_tier	duration	streaming	gaming	social_media	target_offer
9990	C09991	Prepaid	Realme	5.32	0.356520	14.25	14	108000	4	0.138354	0	22	6gb 20k (internet + game mingguan)	mid	7 hari	no	yes	no	Allrounder offer
9991	C09992	Prepaid	Vivo	12.17	0.513754	15.62	16	169000	2	0.443559	0	4	35gb 100k (internet only 4)	high	30 hari	no	no	no	General Offer
9992	C09993	Prepaid	Samsung	4.12	0.713533	13.02	13	122000	4	0.299439	0	16	8gb 25k (internet only mingguan 1)	mid	7 hari	no	no	no	General Offer
9993	C09994	Postpaid	Oppo	2.36	0.320020	13.29	18	100000	1	0.359935	0	5	50gb 150k (internet only 5)	mid	30 hari	no	no	no	General Offer
9994	C09995	Prepaid	Realme	3.16	0.573060	6.66	11	118000	0	0.265929	0	3	25gb 80k (internet only 3)	mid	30 hari	no	no	no	General Offer
9995	C09996	Postpaid	Huawei	12.08	0.396157	6.77	11	145000	1	0.235407	0	15	10gb 15k (internet only harian 2)	mid	1 hari	no	no	no	General Offer
9996	C09997	Postpaid	Vivo	4.49	0.504912	3.90	17	106000	2	0.242680	1	15	10gb 15k (internet only harian 2)	mid	1 hari	no	no	no	General Offer
9997	C09998	Postpaid	Xiaomi	12.04	0.801877	20.12	21	163000	4	0.159048	0	7	100gb 220k (internet only 7)	high	30 hari	no	no	no	General Offer
9998	C09999	Prepaid	Xiaomi	11.07	0.586104	8.04	14	140000	5	0.031456	1	6	80gb 200k (internet only 6)	mid	30 hari	no	no	no	General Offer
9999	C10000	Prepaid	Xiaomi	3.29	0.651369	13.47	16	99000	4	0.275393	0	1	10gb 50k (internet only 1)	mid	30 hari	no	no	no	General Offer

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters